package net.servir.capacidades.model.xls;

import java.io.Serializable;
import java.util.LinkedList;
import java.util.List;

import net.servir.capacidades.model.StoredProcedureParameter;
import net.servir.capacidades.model.Enumerados.ExportCommandType;

public class XlsTableConfig implements Serializable{

	/**
	 * 
	 */
	private static final long serialVersionUID = -530543854765845172L;
	private ExportCommandType command_type = ExportCommandType.SQL;
	private String sql;
	private List<XlsColumnConfig> columns;
	private int rowStart = 1;
	private int colStart = 1;
	private List<StoredProcedureParameter> parameters;
	
	public XlsTableConfig(String sql) {
		super();
		this.sql = sql;
		this.columns = new LinkedList<XlsColumnConfig>();
	}
	
	public XlsTableConfig(String sql, int rowStart, int colStart) {
		super();
		this.sql = sql;
		this.rowStart = rowStart;
		this.colStart = colStart;
	}

	public XlsTableConfig(String sql, List<XlsColumnConfig> columns) {
		super();
		this.sql = sql;
		this.columns = columns;
	}

	public XlsTableConfig(String sql, List<XlsColumnConfig> columns,
			int rowStart, int colStart) {
		super();
		this.sql = sql;
		this.columns = columns;
		this.rowStart = rowStart;
		this.colStart = colStart;
	}
	
	public ExportCommandType getCommand_type() {
		return command_type;
	}
	public void setCommand_type(ExportCommandType commandType) {
		command_type = commandType;
	}
	public String getSql() {
		return sql;
	}
	public void setSql(String sql) {
		this.sql = sql;
	}
	public List<XlsColumnConfig> getColumns() {
		return columns;
	}
	public void setColumns(List<XlsColumnConfig> columns) {
		this.columns = columns;
	}
	public int getRowStart() {
		return rowStart;
	}
	public void setRowStart(int rowStart) {
		this.rowStart = rowStart;
	}
	public int getColStart() {
		return colStart;
	}
	public void setColStart(int columStart) {
		this.colStart = columStart;
	}
	public List<StoredProcedureParameter> getParameters() {
		return parameters;
	}
	public void setParameters(List<StoredProcedureParameter> parameters) {
		this.parameters = parameters;
	}

	
}
